UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sl55ni8T5kezdAuFqnd5GRzb35zRGZqoTqmSgjbohtQ='
WHERE
key_id = '9a027a2c700e2a4f946bd383eee76d10797f13c5103014e8540ab2dd171273d2'
AND (
token = 'sl55ni8T5kezdAuFqnd5GRzb35zRGZqoTqmSgjbohtQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)