UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WJ26ZBI1d2HnezHTzEJrIN9yUPzjB9AOx6iCaVWfsEA='
WHERE
key_id = '4b5de3ea34d22caefebb804099ae3021fd6f4c0558bc11198096327218a38694'
AND (
token = 'WJ26ZBI1d2HnezHTzEJrIN9yUPzjB9AOx6iCaVWfsEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)