UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rPrH5msNhSIZHp1VEho7Khxj2tSMmjHk/6xNuDKOrko='
WHERE
key_id = '42e6cc72bf2b27638e8f59219165e382b185dd8ccea8ce2023fc32c1f78799bc'
AND (
token = 'rPrH5msNhSIZHp1VEho7Khxj2tSMmjHk/6xNuDKOrko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)