UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WaPAYFtTr/Ux9lWLYyM6DBIp2Alt2aemUiXa9A9r7b8='
WHERE
key_id = 'd5480e48a39a701a61249542af9670cec432b2269e88d870d0f751d986a07e1e'
AND (
token = 'WaPAYFtTr/Ux9lWLYyM6DBIp2Alt2aemUiXa9A9r7b8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)