UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B9Co8+wawFHsQusR93rNBZjNBWu2ExbwzqUqM1kbxD8='
WHERE
key_id = '56fca80864001bb13f545ca5c20587b26fede31a1e2442de8019b19646fe8eac'
AND (
token = 'B9Co8+wawFHsQusR93rNBZjNBWu2ExbwzqUqM1kbxD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)