UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/ZCq1q5HWYDgo6aQJtFwmiIVtBNwKeEyTDJb+Xh1YEc='
WHERE
key_id = '59f7cf823d017636db64ab22d2ee5c23d488e22660c1b5397793def8c5d9ae91'
AND (
token = '/ZCq1q5HWYDgo6aQJtFwmiIVtBNwKeEyTDJb+Xh1YEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)