UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YXb4g4ZKY8Es/nFf/N2QNT1pHTyl2UrMxT9s9V+/wcI='
WHERE
key_id = '831c0e1e81f6bc572192ac247958ec420592e0852847429cdabeb581b5e842d2'
AND (
token = 'YXb4g4ZKY8Es/nFf/N2QNT1pHTyl2UrMxT9s9V+/wcI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)