UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZN5lPX9SZQuAMs9X6efGy+PQw2tbo3+nNBi/2rJPYZY='
WHERE
key_id = '20e0049c0c31483dd08f03b0a1c453aa5e51d17ddab2ce0f7e80ad8d04ced503'
AND (
token = 'ZN5lPX9SZQuAMs9X6efGy+PQw2tbo3+nNBi/2rJPYZY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)