UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TIrOCDgZZL+nfhgcb4owersKuxvkoIvxx8FEB1H1P9w='
WHERE
key_id = 'e32a47ba856726513b1c47fe05eaeb1a5ad28032d9bdc49edc5859a6e6161925'
AND (
token = 'TIrOCDgZZL+nfhgcb4owersKuxvkoIvxx8FEB1H1P9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)