UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CYRTk+Yj9my57wwlzJvytCPBlfc8dAurh8h2b0aIBDM='
WHERE
key_id = '31a3f177565fe19e69f4634ef6bdcf5b5bd95f61012f82b6915b1887a3ed9fe3'
AND (
token = 'CYRTk+Yj9my57wwlzJvytCPBlfc8dAurh8h2b0aIBDM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)