UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4VhOdTd4bFgMoRyPcZQczq6E40Jrjp4Fo/QdryRV3YU='
WHERE
key_id = 'b7d0d18ef60a26edb15b0b235906b498e69bfed01452403bca49f2a4858ba13a'
AND (
token = '4VhOdTd4bFgMoRyPcZQczq6E40Jrjp4Fo/QdryRV3YU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)