UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '06KLy8pE1MWfH2w8q2kS4SwLj9z/GTJ10apd+gEJSbE='
WHERE
key_id = '5c39caba630d13d63f66bb99a1aa34499ad493bb8bce886fe77bb143d355f621'
AND (
token = '06KLy8pE1MWfH2w8q2kS4SwLj9z/GTJ10apd+gEJSbE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)