UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uW7+LG/UsOFFBFhQwGkbDJtmaqI8ZZsEieO1MhH7W3Q='
WHERE
key_id = 'bc3afd00526dce65b7759c1e7b7e2c73c193a7913b0b67c152ac2e9062ee3efc'
AND (
token = 'uW7+LG/UsOFFBFhQwGkbDJtmaqI8ZZsEieO1MhH7W3Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)