UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ic6Y2mAZaNFjhBk6JiRkqplSaNqEjGaRGpJ7Jx8qRug='
WHERE
key_id = '12cc952c659fcf7d2108603aa2d89f1bc361d3a69071076a2e55c85c3afc7bde'
AND (
token = 'ic6Y2mAZaNFjhBk6JiRkqplSaNqEjGaRGpJ7Jx8qRug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)