UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'caVltbYk/tnnCsrFCQEs0TvCLPxqXZFiYh4U2iv3wRI='
WHERE
key_id = 'd90a106f71f413a7f708ad5bda58e77c15696f3f19796ed5cd96ae64327400bf'
AND (
token = 'caVltbYk/tnnCsrFCQEs0TvCLPxqXZFiYh4U2iv3wRI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)