UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgQOcEkfc6y6kleK0FxgsdtUAfoDB1hOM/k/xHHcopQ='
WHERE
key_id = '057c73f072386bb26f1d816f85e7230d354cf5688cb4184cc270d55b5c4a2efd'
AND (
token = 'zgQOcEkfc6y6kleK0FxgsdtUAfoDB1hOM/k/xHHcopQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)