UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8yQiOGp6kX99s8vMPMt+29xhBiMrS3CUOqHa9CEpCig='
WHERE
key_id = 'd6877e33e49a7021aaa50caa9dd4bce1779c434c09749ced2b33220ed2edff60'
AND (
token = '8yQiOGp6kX99s8vMPMt+29xhBiMrS3CUOqHa9CEpCig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)