UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/7fa7Z1nlp6HNlaiAKpGyuk9JUi8Blaqxr+u3yqv4+s='
WHERE
key_id = 'b50e18f487548132306c3d87f6e8d66f022515f7fc3a77debc5ee0b2d77fe980'
AND (
token = '/7fa7Z1nlp6HNlaiAKpGyuk9JUi8Blaqxr+u3yqv4+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)