UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3HgyXcVzqmSPvhR7lqRPC4QVdteEJJwEWxqSiKw2Rds='
WHERE
key_id = '3e9b82d3c5d1ffef464812d5c52bc6e55e9cd93d649652b8706a8418ce2347a2'
AND (
token = '3HgyXcVzqmSPvhR7lqRPC4QVdteEJJwEWxqSiKw2Rds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)