UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JL0CXhvZdxkBmiSZ/3iajUpkYPWSbbC3CQF5BdxMRlw='
WHERE
key_id = 'e8469a579d8598189faf75a283cb537631717ec894da046379117fd7b7f53ce2'
AND (
token = 'JL0CXhvZdxkBmiSZ/3iajUpkYPWSbbC3CQF5BdxMRlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)