UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0bbY7CZoEP9HIssVot6WZ8ZNNOW1eXzIG5kFsCjUzMs='
WHERE
key_id = 'a767272adc742bcbc892810d7d502d53e3ff8a5e3a817b75bbf6944d09ad13a1'
AND (
token = '0bbY7CZoEP9HIssVot6WZ8ZNNOW1eXzIG5kFsCjUzMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)