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