UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pso5eFCNSjzOjOtAP4tyXvXQqAEccKYFuT18iyaSzPg='
WHERE
key_id = 'e28e8cc8491c646a8c8f4b505053cdd15f6c3f7f2612ce9bf82df7a4b2b05c0f'
AND (
token = 'Pso5eFCNSjzOjOtAP4tyXvXQqAEccKYFuT18iyaSzPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)