UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1D3gkrvNOt0FIiDODeBSKhqYpsVjVZyIpcyeHRc9R5Q='
WHERE
key_id = '2578ca8fa4b03eecbd901567686a9a926ef3c2b5ea53a3f4056468098931001b'
AND (
token = '1D3gkrvNOt0FIiDODeBSKhqYpsVjVZyIpcyeHRc9R5Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)