UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bv7SygWjpawOCVlIjfdHFTOVtjxtIqBMgImhK9/aDww='
WHERE
key_id = '13fca0b5eb68be7ea78e8d7fcc1b7c09f6c9f093b0be5339f4bac54610cd7df2'
AND (
token = 'bv7SygWjpawOCVlIjfdHFTOVtjxtIqBMgImhK9/aDww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)