UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ziOCbAF4SeKZ1JP7KpTwN6HbNymsHYOwhQUiwijje34='
WHERE
key_id = '3cd36a51fc357585fb6c535f7bfcdce58182d3407ee35159b9f10c3d9578f496'
AND (
token = 'ziOCbAF4SeKZ1JP7KpTwN6HbNymsHYOwhQUiwijje34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)