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