UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BxuZg8ycemgrp0yRvR8K/fg4Rq9sQetL9IKTW+Si3Co='
WHERE
key_id = '6adc21b470172e54aa36f979757e0a678457aa223553778a35169f82a06d1300'
AND (
token = 'BxuZg8ycemgrp0yRvR8K/fg4Rq9sQetL9IKTW+Si3Co='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)