UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQl65QEXoJLsDcaqLwg9TGaZSDDrB/q6Iv0cWTHpEV0='
WHERE
key_id = 'b5a9ed90e62bece545cd9abf76ad5daa9563a0d7d89b30f697bc74bea68e198f'
AND (
token = 'zQl65QEXoJLsDcaqLwg9TGaZSDDrB/q6Iv0cWTHpEV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)