UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '19RMGlL1qT/WMgEBebcHUFJQ20lL+fufDNpp8mVHRBs='
WHERE
key_id = 'a9aca7df06668380f8cc3af7aea9ce8000fb21c293253667f93c7b1dbdd576cc'
AND (
token = '19RMGlL1qT/WMgEBebcHUFJQ20lL+fufDNpp8mVHRBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)