UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cXdGbzayJ646XWkXBeSkW4kXL7iVQ1udvAVgQ6BrYAw='
WHERE
key_id = '6f9384e39bc82ce371e218e2535308566ed3d0c5cf68b96272b2da3cc9dea669'
AND (
token = 'cXdGbzayJ646XWkXBeSkW4kXL7iVQ1udvAVgQ6BrYAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)