UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jnhxJo0sDL9Ox46Av/c9Lpuzs0xRLrUZSFmrm3SfGgE='
WHERE
key_id = '3fcf30aa72c0fc2a9ec8194e0dc1ac57f759e0d2e48cac24c91e7e3e1a98ee1d'
AND (
token = 'jnhxJo0sDL9Ox46Av/c9Lpuzs0xRLrUZSFmrm3SfGgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)