UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HNw9m80PkK8Ca4XS25Mn/JhaqHPZrEXOzxwCjhwv758='
WHERE
key_id = '019a02f847ec5d745bce9be68a518fd0daba29fd5e47a16583ad136eb24f6b93'
AND (
token = 'HNw9m80PkK8Ca4XS25Mn/JhaqHPZrEXOzxwCjhwv758='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)