UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WN5BVRNhvrProy1936P1ypxhuGAu9HTKpwV4Ig0GEkg='
WHERE
key_id = 'a6876e395a94449f7c4253392f98894295608900398050275ff74925cdfea9a0'
AND (
token = 'WN5BVRNhvrProy1936P1ypxhuGAu9HTKpwV4Ig0GEkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)