UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tS+eCGWTMVJbrpi6IEcvQ1JfcxwueMMjbeVo40kjQtw='
WHERE
key_id = '39f480ea772aa1063876bb45e282f011a6de749341e426c9607d21a92de57162'
AND (
token = 'tS+eCGWTMVJbrpi6IEcvQ1JfcxwueMMjbeVo40kjQtw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)