UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6qNK/jcuy7TmQv6PGguvZV8ye9ZnaJsctGciernYRHA='
WHERE
key_id = 'a10228fa0c00b0e55ee320ff429b305303bd8309661e2ec60d1f999d4d834e60'
AND (
token = '6qNK/jcuy7TmQv6PGguvZV8ye9ZnaJsctGciernYRHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)